{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["StartHere","5.ID","Financial information ","SI and regression Pt 1","Current operations Pt2 & Pt3 ","Franchise operations Pt2 & Pt3","Expected Values Pt3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"StartHere","index":0,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[[9,2,10,2],[11,2,12,2]]}
[]
[null,"Student Identification Sheet (version5.2)"]
[]
[null,"Name","Melissa salgado"," <<- enter your name here",null,null,"(1)","Add your name to Cell C4 and your Student ID to cell C6. Then  Click [Start Here] to finish loading data."]
[null,null,null,null,null,null,"(2)","Change the file name to include your name. "]
[null,"Student ID",2434822," <<- enter your Student ID here",null,null,"(3)","When done with your work, Click [I'm Done]"]
[null,null,null,null,null,null,"(3)","Upload the file to the applicable iCollege"]
[null,"Date/time",{"$f":"NOW()","v":"2021-04-22T23:47:16.440"},null,null,null,null," assignment folder to receive credit for this workshop/tutorial"]
[null,null,"Spring 2021",null,null,null,"(4)","Never use a file created or started by another student (that is academic dishonesty).\nAll text, codes, writing, data entry, formulas, configuration and instructions must be performed by the individual submitting the work."]
[null,null,"You must use Excel Desktop. Cloud Excel 365 will not work for this class.",null,"2021-04-01T23:34:17.040","Melissa salgado started S01"]
[]
[null,null,"Collaboration Started"]
[]
[null,null,"Individual Challenge started"]
[null,null,"Kurt Schmitz © 2020 Do not post or reproduce."]
[]
[null,"Excel release",{"$f":"INFO(\"release\")","v":"16.0"},"<< Mac Users below 16.24, please update!"]
[null,"OS",{"$f":"INFO(\"OSVERSION\")","v":"Windows (64-bit) NT :.00"},"<< Windows users with version 16.0 are good to go."]

{"sheet":"5.ID","index":1,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Do Not Alter or Delete this Worksheet or you submission cannot be graded!",null,null,null,"DirVer"]
["Action","Name","Panther ID","Date/Time","S01"]
["Start S01","Melissa salgado",2434822,"2021-04-01T23:34:17.010","User"]
["Starter Sheet","None",0,"2020-01-01","C:\\Users\\HP\\AppData\\Local\\Temp"]
[null,null,null,null,"Welcome to Microsoft Excel version 16.0 build 4266 running on Windows (64-bit) NT :.00!"]

{"sheet":"Financial information ","index":2,"n_rows":64,"n_cols":26,"rows_kept":64,"cut":false,"hidden":false,"merged":[[36,1,36,2]]}
["Donut Information ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spring 2021"]
["Based on the below data, create the profit model for Donuts to Go.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Melissa salgado"]
["Assume that each customer will buy one donut and one cup of coffee"]
[" "]
[null,null,null,null,null,"Enter totals "]
[null,"Time period",null,null,"Fixed Costs",{"$f":"C11+C13+C17+C18+C19+C14+C20+C21+C23+C25+C26","v":5550}]
["Revenue: Cup of Coffee",null,4,null,"Varible Costs",{"$f":"C9+C15+C16","v":0.85}]
["Revenue: Donut"," ",3.5,null,"Coffee",{"$f":"C15+C16","v":0.35}]
["Donut ingredients per donunt)","per donut",0.5,null,"Donut",{"$f":"C9","v":0.5}]
["paper products: napkins, plates etc"]
["Insurance","month",200]
[" "]
["Maintenance & Repairs to equipment","month",0]
["Marketing & Promotion: Advertising","month",50]
["Coffee ","per cup",0.25]
["Coffee cups ","per cup",0.1]
["Payroll:  Wages (Owner/ Manager)","month",2500]
["Payroll:  Wages (per Employees)","month",1000,null,null,null,null,null," "]
["Donut and Coffee equipment rent ","month",500]
["Professional Fees: Accounting","month",50]
["Professional Fees: Legal","month",25]
["Powdered and Liquid Beverages",null,0]
["Rent","month",1000]
["Previous research expense for Donuts advancements",null,1500]
["Supplies: Office","month",25]
["Utilities","month",200," "]
[" ",null," "]
[]
[]
["Additional Data"]
["Monthly Production","Lost Sales","Day old revenue","High demand, % above Average","Low Demand, % below average"]
[4000,3,1.25,0.22,0.26]
["Franchise "]
["Monthly Fixed Expense increase",7000]
["Monthly Production Increase",0.32]
["Monthly demand increase",0.24]
["States of Natures ","probabilities "]
["High demand",0.2]
["Average demand",0.55000000000000004]
["Low demand",0.25]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total "]

{"sheet":"SI and regression Pt 1","index":3,"n_rows":102,"n_cols":26,"rows_kept":102,"cut":false,"hidden":false,"merged":[]}
["Month","Demand","Yearly average","Seasonal Index","Average SI","Deseasonalized","Time period",null,null,"Regression Output"]
[1,2302,null,{"$f":"B2/$C$13","v":0.77842590244314824},{"$f":"AVERAGEIF(A$2:A$37,A2,D$2:D$37)","v":0.73978345385053446},{"$f":"B2/E2","v":3111.7213936297298},1,null,"CLICK CELL J2 as output cell for regression",{"$f":"INTERCEPT(F2:F37,Time__period)","v":2775.3436534579396},"Intercept"]
[2,2792.5,null,{"$f":"B3/$C$13","v":0.94428945811142107},{"$f":"AVERAGEIF(A$2:A$37,A3,D$2:D$37)","v":0.84698170510550996},{"$f":"B3/E3","v":3297.0015564292898},2,null,null,{"$f":"SLOPE(F2:F37,Time__period)","v":30.861634922264596},"Slope"]
[3,2454.5,null,0.82999408234001182,0.80703171156512477,3041.3922586013896,3]
[4,3254,null,1.1003466057993068,1.0255014459216618,3173.0818254239434,4]
[5,3586.5,null,{"$f":"B6/$C$13","v":1.2127821455744356},1.0987416470781692,3264.1886375540662,5]
[6,2635.5,null,0.89119959421760087,1.0209225040962251,2581.4887902124215,6]
[7,1986,null,0.67156987065686025,0.76656181294819437,2590.7891137465485,7]
[8,2685,null,0.90793811818412373,0.92259610564011207,2910.2659154810799,8]
[9,2868,null,0.96981993406036016,0.9578435785236542,2994.2258467927641,9]
[10,2948,null,0.99687209400625576,1.0842937621602819,2718.8203998578588,10]
[11,3451.5,"Put yearly average in below cell ",1.1671316256657367,1.2087558175171524,2855.4154197078128,11]
[12,4523.5,{"$f":"AVERAGE(B2:B13)","v":2957.25},1.5296305689407388,1.5209864555933794,2974.0567270438028,12]
[1,2403,null,{"$f":"B14/$C$25","v":0.72807150431752765},0.73978345385053446,3248.247831838506,13]
[2,2473.5,null,{"$f":"B15/$C$25","v":0.74943190425693074},0.84698170510550996,2920.3700447011092,14]
[3,2583.5,null,0.78276018785032575,0.80703171156512477,3201.2372785075127,15]
[4,3362,null,1.0186335403726707,1.0255014459216618,3278.3961576752604,16]
[5,3400.5,null,1.0302984396303589,1.0987416470781692,3094.9040741677409,17]
[6,3628.5,null,1.0993788819875776,1.0209225040962251,3554.1385222104996,18]
[7,2614,null,0.79200121193758521,0.76656181294819437,3410.0315928164541,19]
[8,2979,null,0.90259051658839573,0.92259610564011207,3228.9319039918573,20]
[9,3129,null,0.94803817603393425,0.9578435785236542,3266.712926992524,21]
[10,3912,null,1.1852749583396456,1.0842937621602819,3607.8783596485564,22]
[11,4162.5,"Put yearly average in below cell ",1.261172549613695,1.2087558175171524,3443.6235504950805,23]
[12,4958.5,{"$f":"AVERAGE(B14:B25)","v":3300.5},1.5023481290713527,1.5209864555933794,3260.0553290696794,24]
[1,2695,null,{"$f":"B26/$C$37","v":0.71285295479092725},0.73978345385053446,3642.9579304222943,25]
[2,3203,null,{"$f":"B27/$C$37","v":0.8472237529481782},0.84698170510550996,3781.6637368820107,26]
[3,3056,null,0.80834086450503662,0.80703171156512477,3786.7161304892429,27]
[4,3620,null,0.95752419159300806,1.0255014459216618,3529.9803958311845,28]
[5,3981.5,null,1.0531443560297131,1.0987416470781692,3623.6908017347037,29]
[6,4053.5,null,1.0721890360834967,1.0209225040962251,3970.4286894805732,30]
[7,3161,null,0.83611435625013775,0.76656181294819437,4123.607446401229,31]
[8,3619,null,0.95725968214781665,0.92259610564011207,3922.626572858856,32]
[9,3613,null,0.95567262547666798,0.9578435785236542,3772.0146389338415,33]
[10,4048,null,{"$f":"B35/$C$37","v":1.070734234134944},1.0842937621602819,3733.3056236854181,34]
[11,4529,"Put yearly average in below cell ",1.1979632772720259,1.2087558175171524,3746.8278823284609,35,null,"Use the average seasonal Index  in the column for year 2018"]
[12,5788,{"$f":"AVERAGE(B26:B37)","v":3780.5833333333335},{"$f":"B37/$C$37","v":1.5309806687680472},1.5209864555933794,3805.4250770707481,36,"Deseasonalized forecast","Seasonalized forecast"]
[1,null,null,null,0.73978345385053446,null,37,{"$f":"_xlfn.FORECAST.LINEAR(G38,F$2:F$37,Time__period)","v":3917.2241455817293},{"$f":"H38*E2","v":2897.8976079251606},"When you move your forecast to the profit models, you must use an equation, not just copy the values"]
[2,null,null,null,0.84698170510550996,null,38,3948.0857805039941,{"$f":"H39*E3","v":3343.956426274091}]
[3,null,null,null,0.80703171156512477,null,39,3978.9474154262589,3211.1367428990834]
[4,null,null,null,1.0255014459216618,null,40,4009.8090503485237,4112.0649790021771]
[5,null,null,null,1.0987416470781692,null,41,4040.670685270788,4439.6531640349003]
[6,null,null,null,1.0209225040962251,null,42,4071.5323201930523,4156.7189718402042]
[7,null,null,null,0.76656181294819437,null,43,4102.3939551153171,3144.7385476609111]
[8,null,null,null,0.92259610564011207,null,44,4133.2555900375819,3813.3255109838965]
[9,null,null,null,0.9578435785236542,null,45,4164.1172249598467,3988.5729441475278]
[10,null,null,null,1.0842937621602819,null,46,4194.9788598821106,4548.5894101644235]
[11,null,null,null,1.2087558175171524,null,47,4225.8404948043753,5108.0092819943511]
[12,null,null,null,1.5209864555933794,null,48,4256.7021297266401,{"$f":"H49*E13","v":6474.3862848097115}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Melissa salgado"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spring 2021"]

{"sheet":"Current operations Pt2 & Pt3 ","index":4,"n_rows":201,"n_cols":26,"rows_kept":201,"cut":false,"hidden":false,"merged":[]}
["CURRENT OPERATIONS",null,null,null,"Monthly Production","Lost Sales","Day old revenue",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"test"]
["Part 2",null,null,null,{"$f":"'Financial information '!A32","v":4000},{"$f":"'Financial information '!B32","v":3},{"$f":"'Financial information '!C32","v":1.25},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summer 2020 "]
["AVERAGE DEMAND"]
["Month ","January","February","March","April","May","June","July","August","September","October","November","December"]
["Demand",{"$f":"'SI and regression Pt 1'!I38","v":2897.8976079251606},{"$f":"'SI and regression Pt 1'!I39","v":3343.956426274091},{"$f":"'SI and regression Pt 1'!I40","v":3211.1367428990834},{"$f":"'SI and regression Pt 1'!I41","v":4112.0649790021771},{"$f":"'SI and regression Pt 1'!I42","v":4439.6531640349003},{"$f":"'SI and regression Pt 1'!I43","v":4156.7189718402042},{"$f":"'SI and regression Pt 1'!I44","v":3144.7385476609111},{"$f":"'SI and regression Pt 1'!I45","v":3813.3255109838965},{"$f":"'SI and regression Pt 1'!I46","v":3988.5729441475278},{"$f":"'SI and regression Pt 1'!I47","v":4548.5894101644235},{"$f":"'SI and regression Pt 1'!I48","v":5108.0092819943511},{"$f":"'SI and regression Pt 1'!I49","v":6474.3862848097115}]
["satisfied demand",{"$f":"MIN($E$2,B5)","v":2897.8976079251606},{"$f":"MIN($E$2,C5)","v":3343.956426274091},3211.1367428990834,4000,4000,4000,3144.7385476609111,3813.3255109838965,3988.5729441475278,4000,4000,4000]
["Extra donuts(over) ",{"$f":"E2-$B$6","v":1102.1023920748394},{"$f":"$E$2-C6","v":656.04357372590903},{"$f":"$E$2-D6","v":788.8632571009166},0,0,0,855.26145233908892,186.67448901610351,11.427055852472222,0,0,0]
["Unsatisfied customers (short)",{"$f":"B5-B6","v":0},{"$f":"C5-C6","v":0},0,112.0649790021771,439.65316403490033,156.71897184020418,0,0,0,548.5894101644235,1108.0092819943511,2474.3862848097115]
["Revenue"]
["coffee ",{"$f":"'Financial information '!$C$7*B6","v":11591.590431700643},{"$f":"'Financial information '!$C$7*C6","v":13375.825705096364},{"$f":"'Financial information '!$C$7*D6","v":12844.546971596334},{"$f":"'Financial information '!$C$7*E6","v":16000},{"$f":"'Financial information '!$C$7*F6","v":16000},{"$f":"'Financial information '!$C$7*G6","v":16000},{"$f":"'Financial information '!$C$7*H6","v":12578.954190643644},{"$f":"'Financial information '!$C$7*I6","v":15253.302043935586},{"$f":"'Financial information '!$C$7*J6","v":15954.291776590111},{"$f":"'Financial information '!$C$7*K6","v":16000},{"$f":"'Financial information '!$C$7*L6","v":16000},{"$f":"'Financial information '!$C$7*M6","v":16000}]
["donut",{"$f":"'Financial information '!$C$8*B6","v":10142.641627738063},{"$f":"'Financial information '!$C$8*C6","v":11703.847491959319},{"$f":"'Financial information '!$C$8*D6","v":11238.978600146791},{"$f":"'Financial information '!$C$8*E6","v":14000},{"$f":"'Financial information '!$C$8*F6","v":14000},{"$f":"'Financial information '!$C$8*G6","v":14000},{"$f":"'Financial information '!$C$8*H6","v":11006.584916813188},{"$f":"'Financial information '!$C$8*I6","v":13346.639288443637},{"$f":"'Financial information '!$C$8*J6","v":13960.005304516348},{"$f":"'Financial information '!$C$8*K6","v":14000},{"$f":"'Financial information '!$C$8*L6","v":14000},{"$f":"'Financial information '!$C$8*M6","v":14000}]
["Revenue from day old sales ",{"$f":"$G$2*B7","v":1377.6279900935492},{"$f":"$G$2*C7","v":820.05446715738628},986.07907137614575,0,0,0,1069.0768154238613,233.34311127012938,14.283819815590277,0,0,0]
["Total Revenue",{"$f":"SUM(B10:B12)","v":23111.860049532253},{"$f":"SUM(C10:C12)","v":25899.727664213071},25069.60464311927,30000,30000,30000,24654.615922880694,28833.284443649354,29928.58090092205,30000,30000,30000]
["Expenses"]
["Fixed Expenses"]
["Total Fixed Expense",{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550}]
[]
["Variable Expenses"]
["Coffee Variable expense",{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400}]
["Donut Variable expense",{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000}]
["Total Variable Expenses",{"$f":"B19+B20","v":3400},{"$f":"C19+C20","v":3400},3400,3400,3400,3400,3400,3400,3400,3400,3400,3400]
["Expenses: due to lost sales",{"$f":"$F$2*B8","v":0},{"$f":"$F$2*C8","v":0},0,336.19493700653129,1318.959492104701,{"$f":"$F$2*G8","v":470.15691552061253},0,0,0,1645.7682304932705,3324.0278459830533,7423.1588544291344]
["Total  Expenses",{"$f":"B16+B21+B22","v":8950},{"$f":"C16+C21+C22","v":8950},8950,9286.1949370065304,10268.959492104701,9420.1569155206125,8950,8950,8950,10595.768230493271,12274.027845983053,16373.158854429133]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee",{"$f":"B13-B23","v":14161.860049532253},{"$f":"C13-C23","v":16949.727664213071},16119.60464311927,20713.80506299347,19731.040507895297,20579.843084479387,15704.615922880694,19883.284443649354,20978.58090092205,19404.231769506729,17725.972154016948,13626.841145570867,{"$f":"SUM(B25:M25)","v":215579.40734877938}]
[]
["Part 3","You should be able to copy from average to high and low and then just make some modifications"]
["HIGH DEMAND"]
["Month ","January","February","March","April","May","June","July","August","September","October","November","December"]
["Demand",{"$f":"B5*1.22","v":3535.4350816686961},{"$f":"C5*1.22","v":4079.6268400543909},3917.5868263368816,5016.7192743826563,5416.3768601225784,5071.1971456450492,3836.5810281463114,4652.2571234003535,4866.0589918599835,5549.2790804005963,6231.7713240331086,{"$f":"M5*1.22","v":7898.7512674678483}]
["satisfied demand",{"$f":"IF(B30>$E$2,$E$2,B30)","v":3535.4350816686961},{"$f":"IF(C30>$E$2,$E$2,C30)","v":4000},3917.5868263368816,4000,4000,4000,3836.5810281463114,4000,4000,4000,4000,4000]
["Extra donuts(over) ",{"$f":"$E$2-B31","v":464.56491833130394},{"$f":"$E$2-C31","v":0},82.413173663118414,0,0,0,163.41897185368862,0,0,0,0,0]
["Unsatisfied customers (short)",{"$f":"B30-B31","v":0},{"$f":"C30-C31","v":79.626840054390868},0,1016.7192743826563,1416.3768601225784,1071.1971456450492,0,652.25712340035352,866.05899185998351,1549.2790804005963,2231.7713240331086,3898.7512674678483]
["Revenue"]
["coffee ",{"$f":"'Financial information '!$C$7*B31","v":14141.740326674784},{"$f":"'Financial information '!$C$7*C31","v":16000},{"$f":"'Financial information '!$C$7*D31","v":15670.347305347526},{"$f":"'Financial information '!$C$7*E31","v":16000},{"$f":"'Financial information '!$C$7*F31","v":16000},{"$f":"'Financial information '!$C$7*G31","v":16000},{"$f":"'Financial information '!$C$7*H31","v":15346.324112585246},{"$f":"'Financial information '!$C$7*I31","v":16000},{"$f":"'Financial information '!$C$7*J31","v":16000},{"$f":"'Financial information '!$C$7*K31","v":16000},{"$f":"'Financial information '!$C$7*L31","v":16000},{"$f":"'Financial information '!$C$7*M31","v":16000}]
["donut",{"$f":"'Financial information '!$C$8*B31","v":12374.022785840436},{"$f":"'Financial information '!$C$8*C31","v":14000},{"$f":"'Financial information '!$C$8*D31","v":13711.553892179085},{"$f":"'Financial information '!$C$8*E31","v":14000},{"$f":"'Financial information '!$C$8*F31","v":14000},{"$f":"'Financial information '!$C$8*G31","v":14000},{"$f":"'Financial information '!$C$8*H31","v":13428.033598512089},{"$f":"'Financial information '!$C$8*I31","v":14000},{"$f":"'Financial information '!$C$8*J31","v":14000},{"$f":"'Financial information '!$C$8*K31","v":14000},{"$f":"'Financial information '!$C$8*L31","v":14000},{"$f":"'Financial information '!$C$8*M31","v":14000}]
["Revenue from day old sales ",{"$f":"$G$2*B32","v":580.70614791412993},{"$f":"$G$2*C32","v":0},103.01646707889802,0,0,0,204.27371481711077,0,0,0,0,0]
["Total Revenue",{"$f":"SUM(B35:B37)","v":27096.469260429349},{"$f":"SUM(C35:C37)","v":30000},29484.917664605509,30000,30000,30000,28978.631425914446,30000,{"$f":"SUM(J35:J37)","v":30000},30000,30000,30000]
["Expenses"]
["Fixed Expenses"]
["Total Fixed Expense",{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550}]
[]
["Variable Expenses"]
["Coffee Variable expense",{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400}]
["Donut Variable expense",{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000}]
["Total Variable Expenses",{"$f":"B44+B45","v":3400},{"$f":"C44+C45","v":3400},3400,3400,3400,3400,3400,3400,3400,3400,3400,3400]
["Expenses: due to lost sales",{"$f":"$F$2*B33","v":0},{"$f":"$F$2*C33","v":238.8805201631726},0,3050.1578231479689,4249.1305803677351,3213.5914369351476,0,1956.7713702010606,2598.1769755799505,4647.8372412017889,6695.3139720993258,11696.253802403546]
["Total  Expenses",{"$f":"SUM(B41+B46+B47)","v":8950},{"$f":"SUM(C41+C46+C47)","v":9188.8805201631731},8950,12000.157823147969,13199.130580367735,12163.591436935149,8950,10906.771370201061,11548.176975579951,13597.837241201789,15645.313972099326,20646.253802403546]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee",{"$f":"B38-B48","v":18146.469260429349},{"$f":"C38-C48","v":20811.119479836827},20534.917664605509,17999.842176852031,16800.869419632265,17836.408563064851,20028.631425914446,19093.228629798941,18451.823024420049,16402.162758798211,14354.686027900674,9353.7461975964543,{"$f":"SUM(B50:M50)","v":209813.90462884962}]
[]
["Part 3"]
["LOW DEMAND"]
["Month ","January","February","March","April","May","June","July","August","September","October","November","December"]
["Demand",{"$f":"B5*0.74","v":2144.444229864619},{"$f":"C5*0.74","v":2474.5277554428271},2376.2411897453217,3042.928084461611,3285.3433413858261,3075.9720391617511,2327.1065252690742,2821.8608781280832,2951.5439786691704,3365.9561635216733,3779.9268686758196,4791.0458507591866]
["satisfied demand",{"$f":"IF(B55>$E$2,$E$2,B55)","v":2144.444229864619},{"$f":"IF(C55>$E$2,$E$2,C55)","v":2474.5277554428271},2376.2411897453217,3042.928084461611,3285.3433413858261,3075.9720391617511,2327.1065252690742,2821.8608781280832,2951.5439786691704,3365.9561635216733,3779.9268686758196,4000]
["Extra donuts(over) ",{"$f":"$E$2-B56","v":1855.555770135381},{"$f":"$E$2-C56","v":1525.4722445571729},1623.7588102546783,957.07191553838902,714.65665861417392,924.02796083824887,1672.8934747309258,1178.1391218719168,1048.4560213308296,634.04383647832674,220.07313132418039,0]
["Unsatisfied customers (short)",{"$f":"B55-B56","v":0},{"$f":"C55-C56","v":0},0,0,0,0,0,0,0,0,0,791.04585075918658]
["Revenue"]
["coffee ",{"$f":"'Financial information '!$C$7*B56","v":8577.7769194584762},{"$f":"'Financial information '!$C$7*C56","v":9898.1110217713085},{"$f":"'Financial information '!$C$7*D56","v":9504.9647589812866},{"$f":"'Financial information '!$C$7*E56","v":12171.712337846444},{"$f":"'Financial information '!$C$7*F56","v":13141.373365543304},{"$f":"'Financial information '!$C$7*G56","v":12303.888156647005},{"$f":"'Financial information '!$C$7*H56","v":9308.4261010762966},{"$f":"'Financial information '!$C$7*I56","v":11287.443512512333},{"$f":"'Financial information '!$C$7*J56","v":11806.175914676682},{"$f":"'Financial information '!$C$7*K56","v":13463.824654086693},{"$f":"'Financial information '!$C$7*L56","v":15119.707474703278},{"$f":"'Financial information '!$C$7*M56","v":16000}]
["donut",{"$f":"'Financial information '!$C$8*B56","v":7505.5548045261667},{"$f":"'Financial information '!$C$8*C56","v":8660.8471440498943},{"$f":"'Financial information '!$C$8*D56","v":8316.8441641086265},{"$f":"'Financial information '!$C$8*E56","v":10650.248295615638},{"$f":"'Financial information '!$C$8*F56","v":11498.701694850392},{"$f":"'Financial information '!$C$8*G56","v":10765.902137066128},{"$f":"'Financial information '!$C$8*H56","v":8144.8728384417591},{"$f":"'Financial information '!$C$8*I56","v":9876.5130734482918},{"$f":"'Financial information '!$C$8*J56","v":10330.403925342096},{"$f":"'Financial information '!$C$8*K56","v":11780.846572325856},{"$f":"'Financial information '!$C$8*L56","v":13229.744040365369},{"$f":"'Financial information '!$C$8*M56","v":14000}]
["Revenue from day old sales ",{"$f":"$G$2*B57","v":2319.4447126692262},{"$f":"$G$2*C57","v":1906.8403056964662},2029.6985128183478,1196.3398944229862,893.3208232677174,1155.0349510478111,2091.1168434136571,1472.6739023398959,1310.570026663537,792.55479559790842,275.09141415522549,0]
["Total Revenue",{"$f":"SUM(B60:B62)","v":18402.776436653869},{"$f":"SUM(C60:C62)","v":20465.798471517672},19851.507435908261,24018.300527885069,25533.395883661415,24224.825244760945,19544.415782931712,22636.630488300518,23447.149866682314,26037.226022010458,28624.542929223873,30000]
["Expenses"]
["Fixed Expenses"]
["Total Fixed Expense",{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550},{"$f":"'Financial information '!$F$6","v":5550}]
[]
["Variable Expenses"]
["Coffee Variable expense",{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1400}]
["Donut Variable expense",{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000},{"$f":"'Financial information '!$C$9*$E$2","v":2000}]
["Total Variable Expenses",{"$f":"SUM(B69:B70)","v":3400},{"$f":"SUM(C69:C70)","v":3400},3400,3400,3400,3400,3400,3400,3400,3400,3400,3400]
["Expenses: due to lost sales",{"$f":"$F$2*B58","v":0},{"$f":"$F$2*C58","v":0},0,0,0,0,0,0,0,0,0,2373.1375522775597]
["Total  Expenses",{"$f":"B66+B71+B72","v":8950},{"$f":"C66+C71+C72","v":8950},8950,8950,8950,8950,8950,8950,8950,8950,8950,11323.13755227756]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee",{"$f":"B63-B73","v":9452.7764366538686},{"$f":"C63-C73","v":11515.798471517672},10901.507435908261,15068.300527885069,16583.395883661415,15274.825244760945,10594.415782931712,13686.630488300518,14497.149866682314,17087.226022010458,19674.542929223873,18676.86244772244,{"$f":"SUM(B75:M75)","v":173013.43153725856}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Melissa salgado"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spring 2021"]

{"sheet":"Franchise operations Pt2 & Pt3","index":5,"n_rows":75,"n_cols":14,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
["FRANCHISE",null,null,null,"Monthly Production","Lost Sales","Day old revenue"]
["Part 2",null,null,null,{"$f":"'Financial information '!A32*1.32","v":5280},{"$f":"'Financial information '!B32","v":3},{"$f":"'Financial information '!C32","v":1.25}]
["AVERAGE DEMAND"]
["Month ","January","February","March","April","May","June","July","August","September","October","November","December"]
["Demand",{"$f":"'Current operations Pt2 & Pt3 '!B5*1.24","v":3593.3930338271994},{"$f":"'Current operations Pt2 & Pt3 '!C5*1.24","v":4146.5059685798724},{"$f":"'Current operations Pt2 & Pt3 '!D5*1.24","v":3981.8095611948634},{"$f":"'Current operations Pt2 & Pt3 '!E5*1.24","v":5098.9605739626995},{"$f":"'Current operations Pt2 & Pt3 '!F5*1.24","v":5505.1699234032767},{"$f":"'Current operations Pt2 & Pt3 '!G5*1.24","v":5154.3315250818532},{"$f":"'Current operations Pt2 & Pt3 '!H5*1.24","v":3899.4757990995299},{"$f":"'Current operations Pt2 & Pt3 '!I5*1.24","v":4728.5236336200314},{"$f":"'Current operations Pt2 & Pt3 '!J5*1.24","v":4945.8304507429348},{"$f":"'Current operations Pt2 & Pt3 '!K5*1.24","v":5640.2508686038855},{"$f":"'Current operations Pt2 & Pt3 '!L5*1.24","v":6333.9315096729952},{"$f":"'Current operations Pt2 & Pt3 '!M5*1.24","v":8028.2389931640419}]
["satisfied demand",{"$f":"MIN($E$2,B5)","v":3593.3930338271994},{"$f":"MIN($E$2,C5)","v":4146.5059685798724},{"$f":"MIN($E$2,D5)","v":3981.8095611948634},{"$f":"MIN($E$2,E5)","v":5098.9605739626995},5280,5154.3315250818532,3899.4757990995299,4728.5236336200314,4945.8304507429348,5280,5280,5280]
["Extra donuts(over) ",{"$f":"$E$2-B6","v":1686.6069661728006},{"$f":"$E$2-C6","v":1133.4940314201276},1298.1904388051366,181.03942603730047,0,125.66847491814679,1380.5242009004701,551.47636637996857,334.16954925706523,0,0,0]
["Unsatisfied customers (short)",{"$f":"B5-B6","v":0},{"$f":"C5-C6","v":0},0,0,225.1699234032767,0,0,0,0,360.25086860388546,1053.9315096729952,2748.2389931640419]
["Revenue"]
["coffee ",{"$f":"'Financial information '!$C$7*B6","v":14373.572135308797},{"$f":"'Financial information '!$C$7*C6","v":16586.02387431949},{"$f":"'Financial information '!$C$7*D6","v":15927.238244779453},{"$f":"'Financial information '!$C$7*E6","v":20395.842295850798},{"$f":"'Financial information '!$C$7*F6","v":21120},{"$f":"'Financial information '!$C$7*G6","v":20617.326100327413},{"$f":"'Financial information '!$C$7*H6","v":15597.90319639812},{"$f":"'Financial information '!$C$7*I6","v":18914.094534480126},{"$f":"'Financial information '!$C$7*J6","v":19783.321802971739},{"$f":"'Financial information '!$C$7*K6","v":21120},{"$f":"'Financial information '!$C$7*L6","v":21120},{"$f":"'Financial information '!$C$7*M6","v":21120}]
["donut",{"$f":"'Financial information '!$C$8*B6","v":12576.875618395197},{"$f":"'Financial information '!$C$8*C6","v":14512.770890029553},{"$f":"'Financial information '!$C$8*D6","v":13936.333464182022},{"$f":"'Financial information '!$C$8*E6","v":17846.362008869448},{"$f":"'Financial information '!$C$8*F6","v":18480},{"$f":"'Financial information '!$C$8*G6","v":18040.160337786485},{"$f":"'Financial information '!$C$8*H6","v":13648.165296848354},{"$f":"'Financial information '!$C$8*I6","v":16549.83271767011},{"$f":"'Financial information '!$C$8*J6","v":17310.406577600272},{"$f":"'Financial information '!$C$8*K6","v":18480},{"$f":"'Financial information '!$C$8*L6","v":18480},{"$f":"'Financial information '!$C$8*M6","v":18480}]
["Revenue from day old sales ",{"$f":"$G$2*B7","v":2108.2587077160006},{"$f":"$G$2*C7","v":1416.8675392751595},1622.7380485064209,226.29928254662559,0,157.08559364768348,1725.6552511255877,689.34545797496071,417.71193657133153,0,0,0]
["Total Revenue",{"$f":"B10+B11+B12","v":29058.706461419992},{"$f":"C10+C11+C12","v":32515.662303624202},31486.309757467898,38468.503587266874,39600,38814.572031761578,30971.723744372059,36153.272710125195,37511.440317143337,39600,39600,39600]
["Expenses"]
["Fixed Expenses"]
["Total Fixed Expense",{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550}]
[]
["Variable Expenses"]
["Coffee Variable expense",{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998}]
["Donut Variable expense",{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640}]
["Total Variable Expenses",{"$f":"B19+B20","v":4488},{"$f":"C19+C20","v":4488},4488,4488,4488,4488,4488,4488,4488,4488,4488,4488]
["Expenses: due to lost sales",{"$f":"$F$2*B8","v":0},{"$f":"$F$2*C8","v":0},0,0,675.50977020983009,0,0,0,0,1080.7526058116564,3161.7945290189855,8244.7169794921247]
["Total  Expenses",{"$f":"B16+B21+B22","v":17038},{"$f":"C16+C21+C22","v":17038},17038,17038,17713.509770209828,17038,17038,17038,17038,18118.752605811656,20199.794529018985,{"$f":"M16+M21+M22","v":25282.716979492125}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee",{"$f":"B13-B23","v":12020.706461419992},{"$f":"C13-C23","v":15477.662303624202},14448.309757467898,21430.503587266874,21886.490229790172,21776.572031761578,13933.723744372059,19115.272710125195,20473.440317143337,21481.247394188344,19400.205470981015,14317.283020507875,{"$f":"SUM(B25:M25)","v":215761.41702864852}]
[]
["Part 3"]
["HIGH DEMAND"]
["Month ","January","February","March","April","May","June","July","August","September","October","November","December"]
["Demand",{"$f":"'Current operations Pt2 & Pt3 '!B30*1.24","v":4383.939501269183},{"$f":"'Current operations Pt2 & Pt3 '!C30*1.24","v":5058.7372816674442},{"$f":"'Current operations Pt2 & Pt3 '!D30*1.24","v":4857.8076646577329},{"$f":"'Current operations Pt2 & Pt3 '!E30*1.24","v":6220.7319002344939},{"$f":"'Current operations Pt2 & Pt3 '!F30*1.24","v":6716.3073065519975},{"$f":"'Current operations Pt2 & Pt3 '!G30*1.24","v":6288.2844605998607},{"$f":"'Current operations Pt2 & Pt3 '!H30*1.24","v":4757.3604749014257},{"$f":"'Current operations Pt2 & Pt3 '!I30*1.24","v":5768.798833016438},{"$f":"'Current operations Pt2 & Pt3 '!J30*1.24","v":6033.9131499063797},{"$f":"'Current operations Pt2 & Pt3 '!K30*1.24","v":6881.1060596967391},{"$f":"'Current operations Pt2 & Pt3 '!L30*1.24","v":7727.3964418010546},{"$f":"'Current operations Pt2 & Pt3 '!M30*1.24","v":9794.4515716601327}]
["satisfied demand",{"$f":"IF(B30>$E$2,$E$2,B30)","v":4383.939501269183},{"$f":"IF(C30>$E$2,$E$2,C30)","v":5058.7372816674442},4857.8076646577329,5280,5280,5280,4757.3604749014257,5280,5280,5280,5280,5280]
["Extra donuts(over) ",{"$f":"$E$2-B31","v":896.06049873081702},{"$f":"$E$2-C31","v":221.26271833255578},422.19233534226714,0,0,0,522.63952509857427,0,0,0,0,0]
["Unsatisfied customers (short)",{"$f":"B30-B31","v":0},{"$f":"C30-C31","v":0},0,940.73190023449388,1436.3073065519975,1008.2844605998607,0,488.79883301643804,753.91314990637966,1601.1060596967391,2447.3964418010546,4514.4515716601327]
["Revenue"]
["coffee ",{"$f":"'Financial information '!$C$7*B31","v":17535.758005076732},{"$f":"'Financial information '!$C$7*C31","v":20234.949126669777},{"$f":"'Financial information '!$C$7*D31","v":19431.230658630931},{"$f":"'Financial information '!$C$7*E31","v":21120},{"$f":"'Financial information '!$C$7*F31","v":21120},{"$f":"'Financial information '!$C$7*G31","v":21120},{"$f":"'Financial information '!$C$7*H31","v":19029.441899605703},{"$f":"'Financial information '!$C$7*I31","v":21120},{"$f":"'Financial information '!$C$7*J31","v":21120},{"$f":"'Financial information '!$C$7*K31","v":21120},{"$f":"'Financial information '!$C$7*L31","v":21120},{"$f":"'Financial information '!$C$7*M31","v":21120}]
["donut",{"$f":"'Financial information '!$C$8*B31","v":15343.788254442141},{"$f":"'Financial information '!$C$8*C31","v":17705.580485836053},{"$f":"'Financial information '!$C$8*D31","v":17002.326826302065},{"$f":"'Financial information '!$C$8*E31","v":18480},{"$f":"'Financial information '!$C$8*F31","v":18480},{"$f":"'Financial information '!$C$8*G31","v":18480},{"$f":"'Financial information '!$C$8*H31","v":16650.76166215499},{"$f":"'Financial information '!$C$8*I31","v":18480},{"$f":"'Financial information '!$C$8*J31","v":18480},{"$f":"'Financial information '!$C$8*K31","v":18480},{"$f":"'Financial information '!$C$8*L31","v":18480},{"$f":"'Financial information '!$C$8*M31","v":18480}]
["Revenue from day old sales ",{"$f":"$G$2*B32","v":1120.0756234135213},{"$f":"$G$2*C32","v":276.57839791569472},527.74041917783393,0,0,0,653.29940637321783,0,0,0,0,0]
["Total Revenue",{"$f":"SUM(B35:B37)","v":33999.621882932392},{"$f":"SUM(C35:C37)","v":38217.108010421522},36961.297904110834,39600,39600,39600,36333.502968133907,39600,39600,39600,39600,39600]
["Expenses"]
["Fixed Expenses"]
["Total Fixed Expense",{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550}]
[]
["Variable Expenses"]
["Coffee Variable expense",{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998}]
["Donut Variable expense",{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640}]
["Total Variable Expenses",{"$f":"SUM(B44:B45)","v":4488},{"$f":"SUM(C44:C45)","v":4488},4488,4488,4488,4488,4488,4488,4488,4488,4488,4488]
["Expenses: due to lost sales",{"$f":"$F$2*B33","v":0},{"$f":"$F$2*C33","v":0},0,2822.1957007034816,4308.9219196559925,3024.8533817995822,0,1466.3964990493141,2261.739449719139,4803.3181790902172,7342.1893254031638,13543.354714980398]
["Total  Expenses",{"$f":"SUM(B41+B46+B47)","v":17038},{"$f":"SUM(C41+C46+C47)","v":17038},17038,19860.19570070348,21346.921919655993,20062.853381799581,17038,18504.396499049315,19299.739449719138,{"$f":"SUM(K41+K46+K47)","v":21841.318179090216},24380.189325403164,30581.3547149804]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee",{"$f":"B38-B48","v":16961.621882932392},{"$f":"C38-C48","v":21179.108010421522},19923.297904110834,19739.80429929652,18253.078080344007,19537.146618200419,19295.502968133907,21095.603500950685,20300.260550280862,17758.681820909784,{"$f":"L38-L48","v":15219.810674596836},9018.6452850196001,{"$f":"SUM(B50:M50)","v":218282.56159519736}]
[]
["Part 3"]
["LOW DEMAND"]
["Month ","January","February","March","April","May","June","July","August","September","October","November","December"]
["Demand",{"$f":"'Current operations Pt2 & Pt3 '!B55*1.24","v":2659.1108450321276},{"$f":"'Current operations Pt2 & Pt3 '!C55*1.24","v":3068.4144167491058},{"$f":"'Current operations Pt2 & Pt3 '!D55*1.24","v":2946.539075284199},{"$f":"'Current operations Pt2 & Pt3 '!E55*1.24","v":3773.2308247323977},{"$f":"'Current operations Pt2 & Pt3 '!F55*1.24","v":4073.8257433184244},{"$f":"'Current operations Pt2 & Pt3 '!G55*1.24","v":3814.2053285605712},{"$f":"'Current operations Pt2 & Pt3 '!H55*1.24","v":2885.6120913336517},{"$f":"'Current operations Pt2 & Pt3 '!I55*1.24","v":3499.107488878823},{"$f":"'Current operations Pt2 & Pt3 '!J55*1.24","v":3659.9145335497715},{"$f":"'Current operations Pt2 & Pt3 '!K55*1.24","v":4173.7856427668748},{"$f":"'Current operations Pt2 & Pt3 '!L55*1.24","v":4687.109317158016},{"$f":"'Current operations Pt2 & Pt3 '!M55*1.24","v":5940.8968549413912}]
["satisfied demand",{"$f":"IF(B55>=$E$2,$E$2,B55)","v":2659.1108450321276},{"$f":"IF(C55>=$E$2,$E$2,C55)","v":3068.4144167491058},2946.539075284199,3773.2308247323977,4073.8257433184244,3814.2053285605712,2885.6120913336517,3499.107488878823,3659.9145335497715,4173.7856427668748,{"$f":"IF(L55>=$E$2,$E$2,L55)","v":4687.109317158016},5280]
["Extra donuts(over) ",{"$f":"$E$2-B56","v":2620.8891549678724},{"$f":"$E$2-C56","v":2211.5855832508942},2333.460924715801,1506.7691752676023,1206.1742566815756,1465.7946714394288,2394.3879086663483,1780.892511121177,1620.0854664502285,1106.2143572331252,592.89068284198402,0]
["Unsatisfied customers (short)",{"$f":"B55-B56","v":0},{"$f":"C55-C56","v":0},0,0,0,0,0,0,0,0,0,660.89685494139121]
["Revenue"]
["coffee ",{"$f":"'Financial information '!$C$7*B56","v":10636.44338012851},{"$f":"'Financial information '!$C$7*C56","v":12273.657666996423},{"$f":"'Financial information '!$C$7*D56","v":11786.156301136796},{"$f":"'Financial information '!$C$7*E56","v":15092.923298929591},{"$f":"'Financial information '!$C$7*F56","v":16295.302973273698},{"$f":"'Financial information '!$C$7*G56","v":15256.821314242285},{"$f":"'Financial information '!$C$7*H56","v":11542.448365334607},{"$f":"'Financial information '!$C$7*I56","v":13996.429955515292},{"$f":"'Financial information '!$C$7*J56","v":14639.658134199086},{"$f":"'Financial information '!$C$7*K56","v":16695.142571067499},{"$f":"'Financial information '!$C$7*L56","v":18748.437268632064},{"$f":"'Financial information '!$C$7*M56","v":21120}]
["donut",{"$f":"'Financial information '!$C$8*B56","v":9306.8879576124473},{"$f":"'Financial information '!$C$8*C56","v":10739.45045862187},{"$f":"'Financial information '!$C$8*D56","v":10312.886763494696},{"$f":"'Financial information '!$C$8*E56","v":13206.307886563392},{"$f":"'Financial information '!$C$8*F56","v":14258.390101614485},{"$f":"'Financial information '!$C$8*G56","v":13349.718649961998},{"$f":"'Financial information '!$C$8*H56","v":10099.642319667781},{"$f":"'Financial information '!$C$8*I56","v":12246.87621107588},{"$f":"'Financial information '!$C$8*J56","v":12809.700867424201},{"$f":"'Financial information '!$C$8*K56","v":14608.249749684062},{"$f":"'Financial information '!$C$8*L56","v":16404.882610053057},{"$f":"'Financial information '!$C$8*M56","v":18480}]
["Revenue from day old sales ",{"$f":"$G$2*B57","v":3276.1114437098404},{"$f":"$G$2*C57","v":2764.4819790636175},2916.8261558947511,1883.4614690845028,1507.7178208519695,1832.2433392992862,2992.9848858329351,2226.1156389014714,2025.1068330627857,1382.7679465414064,741.11335355248002,0]
["Total Revenue",{"$f":"SUM(B60:B62)","v":23219.442781450798},{"$f":"SUM(C60:C62)","v":25777.590104681913},25015.869220526245,30182.692654577484,32061.410895740151,30438.783303503569,24635.075570835324,28469.421805492646,29474.465834686071,32686.160267292969,35894.433232237599,39600]
["Expenses"]
["Fixed Expenses"]
["Total Fixed Expense",{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550},{"$f":"'Financial information '!$F$6+'Financial information '!$B$34","v":12550}]
[]
["Variable Expenses"]
["Coffee Variable expense",{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998},{"$f":"('Financial information '!$C$15+'Financial information '!$C$16)*$E$2","v":1847.9999999999998}]
["Donut Variable expense",{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640},{"$f":"'Financial information '!$C$9*$E$2","v":2640}]
["Total Variable Expenses",{"$f":"SUM(B69:B70)","v":4488},{"$f":"SUM(C69:C70)","v":4488},4488,4488,4488,4488,4488,4488,4488,4488,4488,4488]
["Expenses: due to lost sales",{"$f":"$F$2*B58","v":0},{"$f":"$F$2*C58","v":0},0,0,0,0,0,0,0,0,0,1982.6905648241736]
["Total  Expenses",{"$f":"B66+B71+B72","v":17038},{"$f":"C66+C71+C72","v":17038},17038,17038,17038,17038,17038,17038,17038,17038,17038,19020.690564824174]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee",{"$f":"B63-B73","v":6181.4427814507981},{"$f":"C63-C73","v":8739.5901046819126},7977.869220526245,13144.692654577484,15023.410895740151,13400.783303503569,7597.0755708353245,11431.421805492646,12436.465834686071,15648.160267292969,18856.433232237599,20579.309435175826,{"$f":"SUM(B75:M75)","v":151016.6551062006}]

{"sheet":"Expected Values Pt3","index":6,"n_rows":59,"n_cols":14,"rows_kept":59,"cut":false,"hidden":false,"merged":[[46,2,46,4],[54,2,54,4],[2,2,2,4],[10,2,10,4],[17,2,17,4],[24,2,24,4],[31,2,31,4],[38,2,38,4]]}
[null,"PAYOFF TABLE"]
[]
[null,null,"State of Nature",null,null,null,null,"Summary of Results ","Methods "]
[null,"Decision Alternatives","Low ","Average ","High ",null,null,{"$f":"B4","v":"Decision Alternatives"},"Maximin","MaxiMax","Laplace ","MinMax regret","EVUII","EOL"]
[null,"Current operations",{"$f":"'Current operations Pt2 & Pt3 '!N75","v":173013.43153725856},{"$f":"'Current operations Pt2 & Pt3 '!N25","v":215579.40734877938},{"$f":"'Current operations Pt2 & Pt3 '!N50","v":209813.90462884962},null,null,"current operations",{"$f":"G13","v":173013.43153725856},{"$f":"G20","v":0},{"$f":"G27","v":199468.91450496251},{"$f":"G34","v":8468.6569663477421},{"$f":"F42","v":203784.81285191322},{"$f":"G58","v":1793.8367171975742}]
[null,"franchise",{"$f":"'Franchise operations Pt2 & Pt3'!N75","v":151016.6551062006},{"$f":"'Franchise operations Pt2 & Pt3'!N25","v":215761.41702864852},{"$f":"'Franchise operations Pt2 & Pt3'!N50","v":218282.56159519736},null,null,"Franchise",0,{"$f":"G21","v":218282.56159519736},{"$f":"G28","v":0},{"$f":"G35","v":0},{"$f":"F43","v":200079.45546134631},{"$f":"G59","v":0}]
[null,null,null,null,null,null,null,"Decision Alternatives","Current operations","Franchise","Franchise","Franchise","Franchise","Franchise"]
[null,"DM UNDER IGNORANCE"]
[null,null,null,null,null,null,null,"Kiana should choose to:"]
[null,"Maximin",null,null,null,null,null,"Franchise"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High ","Min","Max","Because:"]
[null,"Current",{"$f":"C5","v":173013.43153725856},{"$f":"D5","v":215579.40734877938},{"$f":"E5","v":209813.90462884962},{"$f":"MIN(C13:E13)","v":173013.43153725856},{"$f":"IF(F13=MAX($F$13:$F$14),F13,)","v":173013.43153725856},"It has the highest payoff when evaluated using the various decision analysis methods."]
[null,"Franchise",{"$f":"C6","v":151016.6551062006},{"$f":"D6","v":215761.41702864852},{"$f":"E6","v":218282.56159519736},{"$f":"MIN(C14:E14)","v":151016.6551062006},{"$f":"IF(F14=MAX($F$13:$F$14),F14,)","v":0}]
[]
[]
[null,"Maximax"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High ","Max","Max"]
[null,"Current",{"$f":"C5","v":173013.43153725856},{"$f":"D5","v":215579.40734877938},{"$f":"E5","v":209813.90462884962},{"$f":"MAX(C20:E20)","v":215579.40734877938},{"$f":"IF(F20=MAX($F$20:$F$21),F20, )","v":0}]
[null,"Franchise",{"$f":"C6","v":151016.6551062006},{"$f":"D6","v":215761.41702864852},{"$f":"E6","v":218282.56159519736},{"$f":"MAX(C21:E21)","v":218282.56159519736},{"$f":"IF(F21=MAX($F$20:$F$21),F21, )","v":218282.56159519736}]
[]
[]
[null,"Laplace"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High ","Laplace","Max"]
[null,"Current",{"$f":"C5","v":173013.43153725856},{"$f":"D5","v":215579.40734877938},{"$f":"E5","v":209813.90462884962},{"$f":"AVERAGE(C27:E27)","v":199468.91450496251},{"$f":"IF(F27=MAX($F$27:$F$28),F27, )","v":199468.91450496251}]
[null,"Franchise",{"$f":"C6","v":151016.6551062006},{"$f":"D6","v":215761.41702864852},{"$f":"E6","v":218282.56159519736},{"$f":"AVERAGE(C28:E28)","v":195020.21124334881},{"$f":"IF(F28=MAX($F$27:$F$28),F28, )","v":0}]
[]
[]
[null,"Minimax Regret"]
[null,"Regret table","State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High ","Max","Min"]
[null,"Current",{"$f":"MAX($C$5:$C$6)-C5","v":0},{"$f":"MAX($D$5:$D$6)-D5","v":182.00967986913747},{"$f":"MAX($E$5:$E$6)-E5","v":8468.6569663477421},{"$f":"MAX(C34:E34)","v":8468.6569663477421},{"$f":"IF(F34=MIN($F$34:$F$35),F34, )","v":8468.6569663477421}]
[null,"Franchise",{"$f":"MAX($C$5:$C$6)-C6","v":21996.776431057951},{"$f":"MAX($D$5:$D$6)-D6","v":0},{"$f":"MAX($E$5:$E$6)-E6","v":0},{"$f":"MAX(C35:E35)","v":21996.776431057951},{"$f":"IF(F35=MIN($F$34:$F$35),F35, )","v":0}]
[]
[null,"DM UNDER RISK"]
[null,"EVUII"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High "]
[null,"Probability",0.25,0.55000000000000004,0.2,"Expected Value"]
[null,"Current",{"$f":"C41*C5","v":43253.357884314639},{"$f":"D41*D5","v":118568.67404182866},{"$f":"E41*E5","v":41962.780925769926},{"$f":"SUM(C42:E42)","v":203784.81285191322}]
[null,"Franchise",{"$f":"C41*C6","v":37754.163776550151},{"$f":"D41*D6","v":118668.77936575669},{"$f":"E41*E6","v":43656.512319039473},{"$f":"SUM(C43:E43)","v":200079.45546134631}]
[]
[]
[null,"EVUPI"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High ","EVUPI"]
[null,"Probability",0.25,0.55000000000000004,0.2]
[null,"Franchise",{"$f":"C49*C5","v":43253.357884314639},{"$f":"D49*D6","v":118668.77936575669},{"$f":"E49*E6","v":43656.512319039473},{"$f":"SUM(C50:E50)","v":205578.6495691108}]
[]
[null,"EVPI",{"$f":"F50-F42","v":1793.8367171975842}]
[]
[null,"EOL"]
[null,"Regret table","State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High ","EOL","Min"]
[null,"Probability",0.25,0.55000000000000004,0.2]
[null,"Current",{"$f":"C34","v":0},{"$f":"D34","v":182.00967986913747},{"$f":"E34","v":8468.6569663477421},{"$f":"SUMPRODUCT($C$57:$E$57,C58:E58)","v":1793.8367171975742},{"$f":"IF(F58=MIN($F$58:$F$59),F58, )","v":1793.8367171975742}]
[null,"Franchise",{"$f":"C35","v":21996.776431057951},{"$f":"D35","v":0},0,{"$f":"SUMPRODUCT($C$57:$E$57,C59:E59)","v":5499.1941077644879},{"$f":"IF(F59=MIN($F$58:$F$59),F59, )","v":0}]